SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105616 LIMIT 1 [ RunTime:0.004431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105616 [ RunTime:0.001275s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692750,935182,54411,676553,941465,905325,818546,731931,652566,896261,885147,233056,413634,523032,943326,850019,230138,834151,1014001,605040,133085,161432,790339,440801,858372,988304,531978,52701,308466,411995,151110,705883,720637,634078,610900,33985,701543,579654,874075,813690,352532,412296,462893,141751,215964,768244,390617,428732,1038110,843789,419651,326214,999859,382264,981707,411991,384641,697292,366489,771590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000873s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002467s ]