SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514451 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514451 [ RunTime:0.004116s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273166,968226,926158,203172,277994,822418,195352,63342,504240,450017,851175,358260,922229,755866,428143,541945,579142,325930,526919,1015035,128489,997467,529377,898809,549114,114456,840761,762554,673903,1048685,258590,139947,1003301,94663,745042,947882,499407,18369,809620,490352,887983,1008009,94556,122420,383443,127864,568969,447919,53686,431073,957824,959724,247785,22091,868762,1030270,653366,63400,430750,595387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]