SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102218 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102218 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (723388,219304,343161,59078,150688,350437,658268,667392,992666,562598,361253,34839,321742,68712,558972,170716,796782,286641,706027,606515,1005623,68321,289913,792407,162527,245318,208894,608520,60858,247665,1038781,1017386,869914,235394,385364,686209,61676,955517,212588,254865,23262,669464,604822,895278,213571,576065,1037311,904299,261010,1032287,9582,739733,470040,72765,589661,641778,578963,327416,580734,554234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]