SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 152335 LIMIT 1 [ RunTime:0.000522s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 152335 [ RunTime:0.003949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242112,87884,100832,811262,441109,517218,880151,921901,266706,919941,276166,1021226,405723,779000,713850,579430,809220,50296,77258,394830,86402,833189,392971,874305,1035348,357565,543222,654743,928201,532797,25354,354130,439112,857796,794761,16723,871893,106451,433619,253634,492993,1027518,757547,781586,160278,296687,759991,1030404,272710,1014546,86127,440772,1115,830798,382910,751464,700578,1027792,735306,143435) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001887s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 152335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000737s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 152335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]