SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536280 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536280 [ RunTime:0.002684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253474,233879,757997,551093,431615,643172,921397,901502,55369,665870,101154,946971,807526,128215,958120,197833,323833,849737,547581,219559,856576,890836,377203,528488,863031,228267,722911,29380,192748,878361,810280,6090,859459,231990,427609,1037035,102242,621054,893772,939128,374736,860306,797514,149178,781062,327936,924553,818398,448433,343195,1045779,129404,374516,834509,651603,1017714,28771,929188,860601,678652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.008376s ]