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` = 421950 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421950 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (705082,283135,271349,885601,667773,537184,749937,586576,278721,334187,361714,170573,652772,563396,957825,762121,934891,72889,1040947,220221,449074,70457,475396,198165,813029,833987,746106,297018,794962,100156,272899,104149,356736,374409,509164,877614,539139,385977,244651,862354,1011029,996579,622540,387853,1019692,423245,989972,825444,350554,608978,615093,255731,953824,584079,758794,923011,146747,806915,879668,376980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421950 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421950 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]