SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 631810 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 631810 [ RunTime:0.003130s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281028,220456,866275,958680,739685,678734,10461,28334,77889,301738,1008429,309529,275395,424935,488301,940159,303691,32355,553104,76143,783089,364117,985798,245714,938715,26695,770642,941691,489045,235377,977280,871066,705567,934650,725439,154543,839525,991042,724080,456603,969021,446219,777622,88259,898242,611749,810010,619345,262753,336827,656797,287486,626076,428257,170177,331404,127767,764907,111950,138748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 631810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 631810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]