SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 552681 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 552681 [ RunTime:0.002699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72131,473124,88751,622106,770530,328442,543928,790467,1015035,812186,644923,753064,206245,423678,606055,33523,866617,604200,966905,429173,595122,608567,854925,557026,253996,60176,714851,982066,757727,877164,18795,490139,259321,394689,525653,868860,285897,975941,698044,34534,36183,855635,363999,567748,975051,670681,579546,248585,615183,649910,1037962,309987,149976,543458,537889,434606,445097,398524,580389,481274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001749s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 552681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 552681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003707s ]