SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438048 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438048 [ RunTime:0.003292s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440214,799500,1002448,625472,772204,177482,49464,807312,617687,707144,452712,50131,440113,39640,305013,446569,1045087,592064,103615,576223,267491,346518,582470,348470,310234,328190,610792,367145,270858,641424,786431,438973,379964,96714,764860,301443,532311,1004918,919743,554194,771286,814048,337052,91821,349666,724724,63462,179701,614075,619109,42560,91582,511970,135408,34854,974114,12236,334291,174916,202149) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000400s ]