SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580678 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580678 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (588294,971031,447922,276309,436254,240818,426020,65725,794082,707455,1042010,73004,391293,740285,897832,45040,84571,61970,854098,343263,304001,407542,711619,298044,1044851,269519,146118,335283,732326,1035854,449012,248542,623889,381877,986759,396231,191715,687661,291960,563226,676941,796585,531785,274170,931849,173811,387563,261028,798833,184856,161377,340334,568472,436414,561885,499236,184499,284160,744284,591261) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]