SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101976 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101976 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (849412,471119,725873,699114,290314,813659,139881,580435,664651,808202,959166,457348,733059,398722,910424,492490,897826,728917,711351,750820,15587,705900,16162,653413,784761,761488,55053,609138,644092,405462,412102,275846,138210,413677,287736,297289,232545,358497,192831,305233,745957,380453,632432,738913,177995,333316,85543,132670,990064,432531,956487,869511,63184,268013,129138,761226,67221,1014046,620111,29215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]