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` = 507418 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507418 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (718513,326091,976993,509396,70389,925885,117969,285841,580661,718603,463462,628697,206447,512430,648817,668182,604306,772817,140836,944354,816014,564186,238007,364739,5459,811687,859008,1039112,879401,533498,557387,448011,740731,116267,433759,608162,827472,17674,354284,819855,438456,766155,608461,507676,169889,579900,557541,865040,173316,400190,645292,350402,30332,113441,535333,960948,743337,351034,424568,992140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]