SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435501 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435501 [ RunTime:0.001858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (161693,811157,431688,608959,192938,378883,258166,389683,301932,140903,186143,689944,842204,448572,713299,48769,2228,761458,462082,917061,26920,708856,79520,816673,172685,63516,449393,169908,44738,382307,319402,818644,939264,932385,415102,157831,954176,781023,872720,407222,1040370,594831,585243,112589,95115,235161,119100,831068,651099,316188,733540,701537,220934,141504,205716,219319,414415,803294,130898,424399) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]