SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204013 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204013 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (184701,414138,1009323,446303,608820,376137,504799,697110,154044,72820,366112,312275,559096,109924,197316,974808,981484,268631,696780,393368,817375,131711,25628,1025515,300542,317994,891995,1023346,663199,369130,993428,387602,960960,791797,975561,512715,833116,669429,989533,415703,457625,355913,474840,997546,895177,462799,58762,932595,118154,928591,729730,674577,509063,224532,445671,228133,54242,999314,947770,1019914) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002661s ]