SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110436 LIMIT 1 [ RunTime:0.000853s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110436 [ RunTime:0.004763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (48062,982009,966143,1019248,861181,287250,223385,40605,241611,212157,940836,406200,878704,852142,860522,641864,305920,141038,569074,238071,215227,205739,306196,210153,463061,760279,901853,57914,907849,126951,577231,36211,657701,93642,675748,1025267,305667,673741,642378,489688,42060,188884,1044939,793368,351333,699578,764596,75016,40318,876735,199734,708236,897800,686260,451968,1008471,216617,9573,461150,743778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110436 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110436 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002363s ]