SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001538s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478303 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478303 [ RunTime:0.002013s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (846876,1046449,705236,143223,949005,432000,767201,680182,902396,723994,887410,342666,358509,65440,138876,713837,901439,142579,521726,982393,216644,167954,736822,448516,494791,548509,254505,516472,722829,838539,855530,583644,17283,433672,792503,644147,533220,879648,849635,173331,375825,867315,104296,975875,916574,409714,289424,523718,80076,17610,327131,920452,483705,276541,924877,930854,872872,950375,98001,851875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000813s ]