SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000940s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502400 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502400 [ RunTime:0.002516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (844140,250941,589607,112250,97950,95398,904413,652718,63427,365692,589577,382792,897395,414645,945063,458556,880295,1046296,453999,254137,245639,973370,800771,386865,202952,47883,43872,421337,85854,988888,567740,693272,310259,149407,208112,525844,852011,761275,772588,304882,579665,1009202,768799,1043748,1004226,904196,129997,201992,464258,285013,790593,732923,154366,128580,173045,342569,268069,273861,670334,434629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]