SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 213118 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 213118 [ RunTime:0.002105s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125205,234121,484445,914865,1000512,604021,943847,844490,1048443,351063,611879,967499,718608,327265,184724,788748,258581,324007,127815,378101,892163,412482,527905,282238,497526,340946,825028,242814,110788,715777,374637,461396,124357,689877,759762,46097,646495,1019076,479199,35394,1030210,18062,603049,235249,825841,763091,315716,52949,249504,916004,737877,339402,284138,275592,162472,581178,1017480,902117,121970,805690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 213118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 213118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]