SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543024 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543024 [ RunTime:0.001840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432214,495764,952993,881817,679984,972554,246535,182102,448570,582454,707474,1018650,789045,443312,4965,886547,331479,531938,615000,745457,258532,826133,647711,62259,147014,839628,850191,234221,144578,575091,357657,328213,708889,253695,838038,247112,480605,651788,872370,809257,997903,839361,500251,59353,92104,562085,828181,401916,616477,442004,723844,385226,633511,13431,965386,313140,273963,990213,987527,1038095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543024 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000678s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543024 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001694s ]