SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479035 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479035 [ RunTime:0.002529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419198,533565,760039,731246,252927,477124,252783,193865,901082,557708,910478,607176,266811,852058,110112,692003,889860,22038,827250,207203,589655,642191,754796,905740,335542,721620,202871,599531,475446,221283,375907,349849,1022704,13363,351029,364639,257153,225262,991582,335316,116485,345810,50548,88086,372243,729500,661734,617915,749929,101835,74294,516750,881172,898532,614105,402761,664479,191312,752422,1027078) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]