SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015028 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015028 [ RunTime:0.003555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116403,551992,105967,384251,80373,777544,422290,58287,17325,165588,619069,945703,52428,40216,844397,49632,861279,450608,455029,903304,327535,22626,100110,115031,930828,222430,922517,295195,239485,516477,927521,879045,151427,6037,52032,88967,115910,627459,225633,855900,570947,854717,159006,746421,228482,282800,233879,928761,890780,19319,472473,278610,633603,419925,131734,424578,844639,419136,133883,126429) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]