SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450023 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450023 [ RunTime:0.001442s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603887,819118,122324,190515,604172,702339,219122,205988,216156,883818,433517,297972,39606,289993,906744,818236,454679,92405,993298,355298,342873,230052,28874,463091,508414,999271,608372,224819,336795,704950,23749,439525,441963,330272,857799,972203,242300,444587,322424,180759,634934,512118,866788,69801,546013,320301,50409,329624,847994,802452,601076,862275,556123,652035,329673,631352,756712,370767,670564,151233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001931s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]