SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807544 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807544 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410189,547112,163181,344571,203415,886742,133906,524279,258565,843726,959488,443041,404663,55352,1009069,547491,731914,533964,911950,292610,198646,337286,469422,940984,49029,588522,962131,951841,991916,30472,313044,902332,554139,804200,213192,971864,1016410,877949,78387,865748,112812,1003089,478376,583366,959366,635933,533861,907147,980497,660535,35843,331592,748949,898828,752547,118838,900550,669004,7529,45101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807544 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807544 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]