SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503250 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503250 [ RunTime:0.001976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12167,12925,264648,798067,293860,397772,438903,481814,459284,705385,98953,757501,501307,571785,81305,642748,278709,171284,96026,812028,63284,122724,522429,762246,828926,50014,528171,799209,215156,405748,242896,674663,517096,391902,953326,991612,207535,910492,540779,568266,337000,1033129,222400,652715,951791,701469,742437,224673,1031110,100797,832927,592778,958177,139636,184465,237074,720026,840078,798828,328922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503250 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503250 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]