SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001503s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546302 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546302 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043806,893718,75665,937898,539193,601662,805537,117103,106027,817987,13866,910411,349737,1040686,545362,828419,996740,448061,249793,680265,157556,66026,800788,880661,226365,89160,1000931,239316,38622,303063,109982,261948,842529,647876,837539,792443,712082,251993,507726,325082,920306,515528,300678,988296,79759,65171,824618,877742,685854,52768,65781,205832,809545,388338,757683,895750,438892,418062,297186,600345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546302 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000624s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546302 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]