SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478993 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478993 [ RunTime:0.001791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035568,398178,622918,56640,732534,665753,861195,278335,168159,587475,332490,356617,614466,577981,117941,789242,311916,107578,59085,526535,848870,334536,775635,71661,806377,772017,532492,954205,179881,327858,782502,104105,586575,955933,968041,1042090,132288,491056,1037625,508984,541133,780810,129638,720359,295161,997866,269691,779038,575089,1000294,156053,599330,981286,69396,806353,552508,354251,828422,515339,208402) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]