SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542534 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542534 [ RunTime:0.001506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409159,79002,367256,144882,686725,718868,459139,439259,642951,62490,354007,274825,487628,107192,635376,268148,241023,642779,626307,738568,836409,934185,50369,109291,768845,639078,233860,365602,885160,97968,438221,856743,650373,447091,870525,160170,735258,588031,1017838,415854,349013,272249,394636,283196,312082,431516,100372,197243,147031,670734,635057,446710,963575,83849,461274,936630,395840,509035,123074,140031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]