SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533828 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533828 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563993,201194,967081,382780,132900,575977,1040403,390150,907564,735741,534437,343310,151067,274367,987413,954509,1010938,80372,995242,157475,987246,98252,733475,378016,427868,781520,245068,399489,129413,523861,67195,732888,379077,145377,662489,908304,735499,232660,682067,606362,216199,276038,833338,200529,1029201,50917,417430,4511,280050,742887,550490,719815,900607,531126,410091,324291,515677,323632,914474,298480) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]