SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522078 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522078 [ RunTime:0.001934s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (275774,312639,102977,703135,886498,190927,1029328,695670,133496,627504,194753,531659,574950,443664,423024,809223,755145,485750,1016917,500924,220177,2312,194995,692668,308660,980141,299306,272541,1016131,819965,418231,420297,878866,546239,379684,897671,748424,470565,846610,552832,986091,538119,1003741,572103,1004016,510223,274126,404641,591121,161116,505569,496267,962249,335370,724051,74018,374038,708557,571745,275068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]