SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001442s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 961043 LIMIT 1 [ RunTime:0.000659s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 961043 [ RunTime:0.003014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (894123,1014886,82926,482559,929182,713353,946533,260947,598375,1025186,45473,1010269,123455,648134,533515,329408,858616,217438,712805,310416,56414,795968,201642,682137,385730,512065,427977,830596,60142,74116,130702,393868,420662,1034287,32771,111655,829614,160467,211057,501541,732319,200687,731704,804378,642950,806177,115736,781323,272903,150202,109078,359812,803821,68956,973559,382362,216048,106487,560079,158194) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 961043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 961043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]