SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541573 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541573 [ RunTime:0.002153s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466230,903225,453636,353283,951105,282820,739156,422530,444937,1014996,926384,960689,696246,828889,787595,279920,1041633,827686,402826,376709,196158,567931,574319,523293,529786,67677,925285,687243,656625,370474,336582,860623,431201,44156,526880,510282,553554,759859,222697,895570,312275,63450,218118,463687,882420,764734,773172,721155,597143,176542,1032939,57694,999923,959533,193568,567309,1003465,739346,145186,570871) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]