SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416212 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416212 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312726,953999,115818,228352,118070,513758,153234,181195,871211,646313,765885,656588,590833,67708,368504,403996,136483,842211,371597,472179,899818,941372,61457,984656,1047244,307746,998679,979805,7926,839896,243803,691579,1044619,47818,586973,340716,393082,787010,698997,1025047,943676,325997,40372,1045849,976703,333312,722964,477054,991066,925717,965296,942078,213323,803216,729286,516478,1001066,969903,181729,459935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]