SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041909 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041909 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391404,688078,504330,1020504,925888,421582,516748,744847,162512,79932,547156,381011,96097,451035,128345,467564,427061,638578,90353,346661,282287,714659,595381,735009,375011,331703,69230,291711,253096,911512,1039964,175169,45484,859250,181189,595665,779926,769293,1013920,449118,751044,985469,865650,226116,774128,1040900,940368,123989,88486,350604,743980,1004998,120019,655085,287277,222143,208877,571641,462269,156905) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]