SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290891 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290891 [ RunTime:0.001744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478144,1033195,357555,403314,799058,835247,925989,192956,81782,407572,733030,872776,675855,985752,780946,1043184,871706,877135,173812,402714,346282,181189,88805,264940,869430,448579,393521,236991,952867,643743,70534,345489,677504,880721,113878,714981,768894,793168,680530,91395,139349,101653,225465,810724,38832,18637,964341,616757,976522,168432,486269,513341,166691,258050,379417,566611,826005,264592,24182,382481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000892s ]