SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514618 LIMIT 1 [ RunTime:0.000792s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514618 [ RunTime:0.002651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (577491,50168,572454,69945,493938,923477,83880,396907,185370,306409,28740,49692,743991,318095,459070,264656,838877,696080,576189,661200,909807,888139,681923,731024,663904,853764,771653,149719,501344,394354,69102,170136,213130,21412,790243,979855,585619,8429,623255,345143,212563,540734,848909,960462,276179,306918,801345,968275,737737,503197,214811,595561,223382,237116,252720,426961,981716,306063,443572,1045124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]