SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001488s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 820328 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 820328 [ RunTime:0.001520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (864046,167616,847361,671196,1026995,348563,508769,276718,117130,286106,108903,480199,53877,32478,395040,86627,731074,1020451,509941,423811,814063,184127,683698,752272,357049,880921,303422,476319,372742,515518,486292,722075,91446,1030458,706365,682970,134708,14207,15742,1014623,918192,564845,789633,835030,430917,926678,245063,191328,1035732,440217,280980,449290,566801,79844,289585,749685,627799,991675,440041,536576) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 820328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 820328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]