SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381475 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381475 [ RunTime:0.001984s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150088,292141,746368,520070,118056,365623,664554,879373,356474,9003,683974,987699,65241,334437,386658,728996,890427,688591,48026,237480,665167,998452,240549,86011,642845,971555,1013622,273661,365988,1023603,941298,110892,118970,362196,1004405,424368,799752,144010,307127,286093,378015,1001834,67837,604091,862931,701730,477817,123701,11027,835796,914688,602904,723478,837350,290211,974357,270281,726044,645923,964028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002758s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001582s ]