SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403289 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403289 [ RunTime:0.001521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599205,379875,303378,828890,528975,856689,1040879,494551,174348,461192,892295,382692,702767,943885,221837,235718,494154,580885,568856,855441,1000417,219591,250542,767233,83680,918911,624961,504599,690687,35389,3915,783705,839691,860283,182091,81420,391860,441173,892306,667641,1017674,1026601,797435,863992,739581,365602,419221,295669,284067,849643,693350,56451,606211,739721,963873,1035841,336016,933887,1000128,614180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403289 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403289 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000778s ]