SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392917 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392917 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (814538,322281,166326,434954,887037,928422,716826,375496,762836,542699,719821,307267,601963,210441,587624,789650,840997,291322,594854,454664,393012,20731,886186,216648,125912,765184,259413,234010,718478,811676,899833,910953,807325,875395,266416,565356,845254,394618,586319,451275,1028218,912774,1040216,1042320,830493,631630,679396,186201,996611,743421,572752,132990,175816,860950,239403,348455,654951,317008,708093,363357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001479s ]