SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531513 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531513 [ RunTime:0.001459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328571,96681,761253,95148,790493,506975,211851,898933,488403,906264,827644,127719,836360,844478,37405,878970,229805,388330,1034516,519877,665163,426234,1038268,588026,941202,666685,1022944,889134,773601,170843,869909,747248,345576,376439,762833,852905,115485,14439,523129,374340,212398,532406,652736,573496,935949,308367,180599,568226,829010,483253,915037,637656,663319,1040464,214439,586837,855741,682390,292259,936588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]