SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519004 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519004 [ RunTime:0.001855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816991,962687,566523,396304,272807,897680,86845,922033,921367,814390,210810,796110,882300,885811,595666,100576,433891,392361,608846,207329,374326,233720,84526,186913,867629,576788,705251,328301,786816,551456,53319,650271,439798,132712,139961,353752,434270,719201,130911,807949,245216,321386,816031,638103,417849,960210,148444,613923,546655,558373,189757,128207,922537,25411,76104,791250,1000482,714869,812258,1020366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]