SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103001 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103001 [ RunTime:0.003503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (225934,1015217,87968,26834,1030273,999559,490795,460241,822892,1003047,942303,84294,402413,781441,916506,936610,822576,821190,937635,347296,690300,137438,84864,969876,370176,17130,320902,206785,811166,205710,460933,865987,44877,311857,951998,730463,314122,370397,802917,183353,767634,928942,733615,251978,364737,334787,663104,663160,293726,913068,424384,1006586,836988,936453,992161,1009251,399168,713570,730431,1035387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]