SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415261 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415261 [ RunTime:0.002186s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (572994,194336,650744,409183,609995,843412,297808,145735,137660,1004485,437786,746162,685115,195587,657071,511936,881462,541096,771384,52220,226102,541346,642900,12629,837671,852003,602805,345387,968656,337607,1005573,373590,466641,288122,796210,930613,131505,1027942,284090,917026,432270,861552,959499,86093,355902,599533,717426,174726,715530,606263,468705,298313,591001,201433,849898,842211,867508,391178,99173,1040057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415261 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415261 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]