SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001847s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506213 LIMIT 1 [ RunTime:0.000656s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506213 [ RunTime:0.006712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391634,935958,476209,408919,244064,397834,315679,426912,440830,24882,435062,1043398,85193,391953,185506,834883,67697,805340,462427,412082,471138,86200,208853,480527,1037603,547558,761069,123016,108232,531479,70387,13866,500810,885585,843181,980874,560628,233195,136275,461548,37752,741709,486736,190177,182978,703550,821513,88121,32174,175366,894786,673143,359904,635310,580580,870792,667972,630935,495928,433660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002611s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]