SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021175 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021175 [ RunTime:0.002215s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (943619,989935,225024,749583,795382,540063,951859,943443,387417,249594,805374,632064,9865,764959,85415,277918,217562,836363,141382,250597,705274,298962,883228,723703,209756,577882,795867,1018622,581629,737711,202386,385786,508175,234024,561830,380989,747890,766350,695042,50026,782195,538879,849903,595464,6570,667810,277043,560722,261911,640656,571536,199130,600665,687067,405601,454519,255288,336728,779670,902888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021175 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021175 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]