SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317209 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317209 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (943601,867498,261531,832441,87666,279734,584480,983645,256920,642148,348758,235212,365300,794900,507519,718083,921545,1038974,349448,964188,339522,987569,823771,810001,638786,458102,201066,539680,304169,780464,754170,61211,152642,4332,676627,920039,999800,291711,1018035,99180,414179,128504,490749,241449,14448,243072,867480,907206,8970,484893,329614,139047,491423,44334,1008221,982446,175784,135878,942058,55247) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]