SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405111 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405111 [ RunTime:0.001520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1256,874008,823826,1000041,1025447,741089,899056,731526,155002,830003,1043321,539898,403914,266533,963038,54327,388409,717445,1029365,168424,129671,952830,130800,924067,1037803,52846,983115,226703,132901,321408,707394,769713,879261,355310,1016934,200772,298791,48644,1027698,633728,89072,202814,820231,223552,750541,919889,740791,329835,31187,591433,763455,1014995,281947,340676,441145,466188,44434,72061,25248,370884) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]