SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 125190 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 125190 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (464223,482729,763525,817539,289764,122641,358151,497562,755524,347714,102731,718681,768352,90551,311057,507710,527817,781444,500695,550633,31439,894472,28748,101134,637779,400782,153121,924495,250473,438310,992275,104335,297041,382259,306440,807020,393577,281773,1044338,771599,786644,1034965,1031607,487459,297893,137514,492249,1022558,295718,715078,701301,995562,750638,722557,136377,650125,964536,613474,493843,588225) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 125190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 125190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]