SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503541 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503541 [ RunTime:0.001490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663138,435835,833901,198068,278908,907889,243616,250309,84125,488342,531748,141150,956024,287537,982893,159393,623483,98241,496672,726074,455051,555798,816873,533052,903751,206293,747854,310760,375331,11729,882945,235389,792878,643185,690810,328551,867718,1039595,476214,607781,802620,820471,903098,639749,806477,146746,128948,850022,612887,270680,786535,25750,1023311,996826,767043,514204,400149,621846,667855,750666) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]