SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 36178 LIMIT 1 [ RunTime:0.001759s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36178 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378191,959753,696377,1024910,978938,338191,671636,184087,1024100,82441,876302,705539,850355,101426,29476,583331,1014533,253505,328230,456223,773054,276185,635501,960848,321358,940518,601999,681404,219553,87694,280577,587499,429212,741818,977697,406972,793546,858003,861743,247932,45737,299866,486671,191701,6407,255296,965514,187936,149676,679700,584814,529345,512626,551793,78996,973545,604268,615189,989395,755359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]