SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001533s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513583 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513583 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14501,230848,441454,659021,575718,219299,181000,994435,315747,671176,951394,305546,122279,313210,979540,98012,194825,415926,28211,323283,978397,1007515,275699,962848,186892,201412,767721,471595,404888,666041,641594,303976,372473,219918,934854,368681,770531,480125,192394,1039034,627890,867496,798468,178603,471535,441647,781944,11602,636026,142327,613422,447809,312573,1047904,230190,412818,240081,960318,484808,179080) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000699s ]