SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562209 LIMIT 1 [ RunTime:0.001649s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562209 [ RunTime:0.001931s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409427,230669,594535,219682,906446,345449,141912,335546,88703,74348,641188,257156,317214,43398,925745,862859,76646,588430,72034,254928,555824,36796,393613,483484,315501,742778,1040677,1001416,355358,919687,9811,771434,206569,581430,636097,835479,718863,917325,689372,631860,527399,606617,709623,680133,931218,813640,169474,249106,748068,317792,129298,625103,636826,600832,562987,1017473,598383,930418,688534,198457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000377s ]