SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026698 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026698 [ RunTime:0.001514s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205681,282790,671309,856396,208495,419356,694308,437540,500633,892714,984234,1025650,66313,5717,901167,352062,187949,559234,169530,9143,1025182,620126,395587,383480,710281,32232,318565,80119,734298,105542,48354,763423,434747,67394,400561,598655,998853,336157,738125,318852,496079,785420,287253,204557,192849,88052,592054,839660,393749,504313,975949,906196,59520,29158,145519,41680,949170,163637,988932,797339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001291s ]