SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 593811 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 593811 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (700924,342335,1024295,110796,1001608,1029821,616591,774236,39185,1005749,977228,342857,904386,352083,796806,460639,1025966,1047411,654767,255325,679599,654898,556496,867688,130661,442611,906735,966471,507426,407773,55026,275349,1013480,707746,175376,303296,117396,742839,726551,930765,901535,525779,429440,573688,139483,387572,817194,570088,925281,984734,1015197,822189,311076,959657,163633,486075,334398,444682,24106,469252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 593811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 593811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]