SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509928 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509928 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (97995,721680,975224,588178,360291,605348,163088,376558,160484,561842,147399,627411,279640,650047,448012,885391,378949,243416,835684,658978,659846,626075,374951,651907,130333,439306,128442,546059,829476,523289,890505,633582,608787,136311,428878,139951,400237,647209,282419,276447,698040,993277,403485,248815,500536,170544,14965,959040,68533,739076,513741,130398,551387,558210,882818,566011,1005410,968604,747343,663643) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001688s ]