SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401417 LIMIT 1 [ RunTime:0.000841s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401417 [ RunTime:0.002516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (277667,124217,113222,416245,558922,78315,51570,125562,30760,354984,979240,16282,286985,563348,850255,911780,351658,228541,399899,742161,992787,710689,149175,670038,85607,1041101,1013991,909588,976419,454039,733840,303923,20564,657283,241902,79693,851599,891931,176865,480388,900903,262567,259197,312107,101009,1034913,567130,793863,439576,101257,933158,470890,497126,547389,692181,33537,37939,1047937,109074,282425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]